The Compute tool in table editor lets you update field
values in a table, based on conditions. These conditions can be used to filter
rows to include in the update.
- Click Toolbar
- Enter the expressions for
updating the field values in the expression box on the top and the expressions
for filtering the rows in the box below.
- Enter the name of the
field whose value you want to change. Select the matching one from the
autocomplete list.
Tip:
For a complete list of field suggestions use the shortcut:
CTRL+SHIFT+C
- Use the assignment
operator ‘=’ to assign the field its new value (numeric or non-numeric).
- Enter a numeric or
string value after the operator:
- Click
Apply
- Whenever you apply a
condition the status bar on the bottom right will show if the filtering process
is still in progress.
Tip: More than one field can be updated by separating the field
expressions with a comma
- To clear the condition box,
click on the drop-down next to Apply and select
Clear